package com.mydesign.demo.bean;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class StoreToAssignmentExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public StoreToAssignmentExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andAssignmentIdIsNull() {
            addCriterion("assignment_id is null");
            return (Criteria) this;
        }

        public Criteria andAssignmentIdIsNotNull() {
            addCriterion("assignment_id is not null");
            return (Criteria) this;
        }

        public Criteria andAssignmentIdEqualTo(String value) {
            addCriterion("assignment_id =", value, "assignmentId");
            return (Criteria) this;
        }

        public Criteria andAssignmentIdNotEqualTo(String value) {
            addCriterion("assignment_id <>", value, "assignmentId");
            return (Criteria) this;
        }

        public Criteria andAssignmentIdGreaterThan(String value) {
            addCriterion("assignment_id >", value, "assignmentId");
            return (Criteria) this;
        }

        public Criteria andAssignmentIdGreaterThanOrEqualTo(String value) {
            addCriterion("assignment_id >=", value, "assignmentId");
            return (Criteria) this;
        }

        public Criteria andAssignmentIdLessThan(String value) {
            addCriterion("assignment_id <", value, "assignmentId");
            return (Criteria) this;
        }

        public Criteria andAssignmentIdLessThanOrEqualTo(String value) {
            addCriterion("assignment_id <=", value, "assignmentId");
            return (Criteria) this;
        }

        public Criteria andAssignmentIdLike(String value) {
            addCriterion("assignment_id like", value, "assignmentId");
            return (Criteria) this;
        }

        public Criteria andAssignmentIdNotLike(String value) {
            addCriterion("assignment_id not like", value, "assignmentId");
            return (Criteria) this;
        }

        public Criteria andAssignmentIdIn(List<String> values) {
            addCriterion("assignment_id in", values, "assignmentId");
            return (Criteria) this;
        }

        public Criteria andAssignmentIdNotIn(List<String> values) {
            addCriterion("assignment_id not in", values, "assignmentId");
            return (Criteria) this;
        }

        public Criteria andAssignmentIdBetween(String value1, String value2) {
            addCriterion("assignment_id between", value1, value2, "assignmentId");
            return (Criteria) this;
        }

        public Criteria andAssignmentIdNotBetween(String value1, String value2) {
            addCriterion("assignment_id not between", value1, value2, "assignmentId");
            return (Criteria) this;
        }

        public Criteria andStoreIdIsNull() {
            addCriterion("store_id is null");
            return (Criteria) this;
        }

        public Criteria andStoreIdIsNotNull() {
            addCriterion("store_id is not null");
            return (Criteria) this;
        }

        public Criteria andStoreIdEqualTo(String value) {
            addCriterion("store_id =", value, "storeId");
            return (Criteria) this;
        }

        public Criteria andStoreIdNotEqualTo(String value) {
            addCriterion("store_id <>", value, "storeId");
            return (Criteria) this;
        }

        public Criteria andStoreIdGreaterThan(String value) {
            addCriterion("store_id >", value, "storeId");
            return (Criteria) this;
        }

        public Criteria andStoreIdGreaterThanOrEqualTo(String value) {
            addCriterion("store_id >=", value, "storeId");
            return (Criteria) this;
        }

        public Criteria andStoreIdLessThan(String value) {
            addCriterion("store_id <", value, "storeId");
            return (Criteria) this;
        }

        public Criteria andStoreIdLessThanOrEqualTo(String value) {
            addCriterion("store_id <=", value, "storeId");
            return (Criteria) this;
        }

        public Criteria andStoreIdLike(String value) {
            addCriterion("store_id like", value, "storeId");
            return (Criteria) this;
        }

        public Criteria andStoreIdNotLike(String value) {
            addCriterion("store_id not like", value, "storeId");
            return (Criteria) this;
        }

        public Criteria andStoreIdIn(List<String> values) {
            addCriterion("store_id in", values, "storeId");
            return (Criteria) this;
        }

        public Criteria andStoreIdNotIn(List<String> values) {
            addCriterion("store_id not in", values, "storeId");
            return (Criteria) this;
        }

        public Criteria andStoreIdBetween(String value1, String value2) {
            addCriterion("store_id between", value1, value2, "storeId");
            return (Criteria) this;
        }

        public Criteria andStoreIdNotBetween(String value1, String value2) {
            addCriterion("store_id not between", value1, value2, "storeId");
            return (Criteria) this;
        }

        public Criteria andUserIdIsNull() {
            addCriterion("user_id is null");
            return (Criteria) this;
        }

        public Criteria andUserIdIsNotNull() {
            addCriterion("user_id is not null");
            return (Criteria) this;
        }

        public Criteria andUserIdEqualTo(String value) {
            addCriterion("user_id =", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdNotEqualTo(String value) {
            addCriterion("user_id <>", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdGreaterThan(String value) {
            addCriterion("user_id >", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdGreaterThanOrEqualTo(String value) {
            addCriterion("user_id >=", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdLessThan(String value) {
            addCriterion("user_id <", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdLessThanOrEqualTo(String value) {
            addCriterion("user_id <=", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdLike(String value) {
            addCriterion("user_id like", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdNotLike(String value) {
            addCriterion("user_id not like", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdIn(List<String> values) {
            addCriterion("user_id in", values, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdNotIn(List<String> values) {
            addCriterion("user_id not in", values, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdBetween(String value1, String value2) {
            addCriterion("user_id between", value1, value2, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdNotBetween(String value1, String value2) {
            addCriterion("user_id not between", value1, value2, "userId");
            return (Criteria) this;
        }

        public Criteria andShootingAddressIsNull() {
            addCriterion("shooting_address is null");
            return (Criteria) this;
        }

        public Criteria andShootingAddressIsNotNull() {
            addCriterion("shooting_address is not null");
            return (Criteria) this;
        }

        public Criteria andShootingAddressEqualTo(String value) {
            addCriterion("shooting_address =", value, "shootingAddress");
            return (Criteria) this;
        }

        public Criteria andShootingAddressNotEqualTo(String value) {
            addCriterion("shooting_address <>", value, "shootingAddress");
            return (Criteria) this;
        }

        public Criteria andShootingAddressGreaterThan(String value) {
            addCriterion("shooting_address >", value, "shootingAddress");
            return (Criteria) this;
        }

        public Criteria andShootingAddressGreaterThanOrEqualTo(String value) {
            addCriterion("shooting_address >=", value, "shootingAddress");
            return (Criteria) this;
        }

        public Criteria andShootingAddressLessThan(String value) {
            addCriterion("shooting_address <", value, "shootingAddress");
            return (Criteria) this;
        }

        public Criteria andShootingAddressLessThanOrEqualTo(String value) {
            addCriterion("shooting_address <=", value, "shootingAddress");
            return (Criteria) this;
        }

        public Criteria andShootingAddressLike(String value) {
            addCriterion("shooting_address like", value, "shootingAddress");
            return (Criteria) this;
        }

        public Criteria andShootingAddressNotLike(String value) {
            addCriterion("shooting_address not like", value, "shootingAddress");
            return (Criteria) this;
        }

        public Criteria andShootingAddressIn(List<String> values) {
            addCriterion("shooting_address in", values, "shootingAddress");
            return (Criteria) this;
        }

        public Criteria andShootingAddressNotIn(List<String> values) {
            addCriterion("shooting_address not in", values, "shootingAddress");
            return (Criteria) this;
        }

        public Criteria andShootingAddressBetween(String value1, String value2) {
            addCriterion("shooting_address between", value1, value2, "shootingAddress");
            return (Criteria) this;
        }

        public Criteria andShootingAddressNotBetween(String value1, String value2) {
            addCriterion("shooting_address not between", value1, value2, "shootingAddress");
            return (Criteria) this;
        }

        public Criteria andShootingTimeStartIsNull() {
            addCriterion("shooting_time_start is null");
            return (Criteria) this;
        }

        public Criteria andShootingTimeStartIsNotNull() {
            addCriterion("shooting_time_start is not null");
            return (Criteria) this;
        }

        public Criteria andShootingTimeStartEqualTo(Date value) {
            addCriterion("shooting_time_start =", value, "shootingTimeStart");
            return (Criteria) this;
        }

        public Criteria andShootingTimeStartNotEqualTo(Date value) {
            addCriterion("shooting_time_start <>", value, "shootingTimeStart");
            return (Criteria) this;
        }

        public Criteria andShootingTimeStartGreaterThan(Date value) {
            addCriterion("shooting_time_start >", value, "shootingTimeStart");
            return (Criteria) this;
        }

        public Criteria andShootingTimeStartGreaterThanOrEqualTo(Date value) {
            addCriterion("shooting_time_start >=", value, "shootingTimeStart");
            return (Criteria) this;
        }

        public Criteria andShootingTimeStartLessThan(Date value) {
            addCriterion("shooting_time_start <", value, "shootingTimeStart");
            return (Criteria) this;
        }

        public Criteria andShootingTimeStartLessThanOrEqualTo(Date value) {
            addCriterion("shooting_time_start <=", value, "shootingTimeStart");
            return (Criteria) this;
        }

        public Criteria andShootingTimeStartIn(List<Date> values) {
            addCriterion("shooting_time_start in", values, "shootingTimeStart");
            return (Criteria) this;
        }

        public Criteria andShootingTimeStartNotIn(List<Date> values) {
            addCriterion("shooting_time_start not in", values, "shootingTimeStart");
            return (Criteria) this;
        }

        public Criteria andShootingTimeStartBetween(Date value1, Date value2) {
            addCriterion("shooting_time_start between", value1, value2, "shootingTimeStart");
            return (Criteria) this;
        }

        public Criteria andShootingTimeStartNotBetween(Date value1, Date value2) {
            addCriterion("shooting_time_start not between", value1, value2, "shootingTimeStart");
            return (Criteria) this;
        }

        public Criteria andShootingTimeEndIsNull() {
            addCriterion("shooting_time_end is null");
            return (Criteria) this;
        }

        public Criteria andShootingTimeEndIsNotNull() {
            addCriterion("shooting_time_end is not null");
            return (Criteria) this;
        }

        public Criteria andShootingTimeEndEqualTo(Date value) {
            addCriterion("shooting_time_end =", value, "shootingTimeEnd");
            return (Criteria) this;
        }

        public Criteria andShootingTimeEndNotEqualTo(Date value) {
            addCriterion("shooting_time_end <>", value, "shootingTimeEnd");
            return (Criteria) this;
        }

        public Criteria andShootingTimeEndGreaterThan(Date value) {
            addCriterion("shooting_time_end >", value, "shootingTimeEnd");
            return (Criteria) this;
        }

        public Criteria andShootingTimeEndGreaterThanOrEqualTo(Date value) {
            addCriterion("shooting_time_end >=", value, "shootingTimeEnd");
            return (Criteria) this;
        }

        public Criteria andShootingTimeEndLessThan(Date value) {
            addCriterion("shooting_time_end <", value, "shootingTimeEnd");
            return (Criteria) this;
        }

        public Criteria andShootingTimeEndLessThanOrEqualTo(Date value) {
            addCriterion("shooting_time_end <=", value, "shootingTimeEnd");
            return (Criteria) this;
        }

        public Criteria andShootingTimeEndIn(List<Date> values) {
            addCriterion("shooting_time_end in", values, "shootingTimeEnd");
            return (Criteria) this;
        }

        public Criteria andShootingTimeEndNotIn(List<Date> values) {
            addCriterion("shooting_time_end not in", values, "shootingTimeEnd");
            return (Criteria) this;
        }

        public Criteria andShootingTimeEndBetween(Date value1, Date value2) {
            addCriterion("shooting_time_end between", value1, value2, "shootingTimeEnd");
            return (Criteria) this;
        }

        public Criteria andShootingTimeEndNotBetween(Date value1, Date value2) {
            addCriterion("shooting_time_end not between", value1, value2, "shootingTimeEnd");
            return (Criteria) this;
        }

        public Criteria andShootingAskForIsNull() {
            addCriterion("shooting_ask_for is null");
            return (Criteria) this;
        }

        public Criteria andShootingAskForIsNotNull() {
            addCriterion("shooting_ask_for is not null");
            return (Criteria) this;
        }

        public Criteria andShootingAskForEqualTo(String value) {
            addCriterion("shooting_ask_for =", value, "shootingAskFor");
            return (Criteria) this;
        }

        public Criteria andShootingAskForNotEqualTo(String value) {
            addCriterion("shooting_ask_for <>", value, "shootingAskFor");
            return (Criteria) this;
        }

        public Criteria andShootingAskForGreaterThan(String value) {
            addCriterion("shooting_ask_for >", value, "shootingAskFor");
            return (Criteria) this;
        }

        public Criteria andShootingAskForGreaterThanOrEqualTo(String value) {
            addCriterion("shooting_ask_for >=", value, "shootingAskFor");
            return (Criteria) this;
        }

        public Criteria andShootingAskForLessThan(String value) {
            addCriterion("shooting_ask_for <", value, "shootingAskFor");
            return (Criteria) this;
        }

        public Criteria andShootingAskForLessThanOrEqualTo(String value) {
            addCriterion("shooting_ask_for <=", value, "shootingAskFor");
            return (Criteria) this;
        }

        public Criteria andShootingAskForLike(String value) {
            addCriterion("shooting_ask_for like", value, "shootingAskFor");
            return (Criteria) this;
        }

        public Criteria andShootingAskForNotLike(String value) {
            addCriterion("shooting_ask_for not like", value, "shootingAskFor");
            return (Criteria) this;
        }

        public Criteria andShootingAskForIn(List<String> values) {
            addCriterion("shooting_ask_for in", values, "shootingAskFor");
            return (Criteria) this;
        }

        public Criteria andShootingAskForNotIn(List<String> values) {
            addCriterion("shooting_ask_for not in", values, "shootingAskFor");
            return (Criteria) this;
        }

        public Criteria andShootingAskForBetween(String value1, String value2) {
            addCriterion("shooting_ask_for between", value1, value2, "shootingAskFor");
            return (Criteria) this;
        }

        public Criteria andShootingAskForNotBetween(String value1, String value2) {
            addCriterion("shooting_ask_for not between", value1, value2, "shootingAskFor");
            return (Criteria) this;
        }

        public Criteria andCostTotalIsNull() {
            addCriterion("cost_total is null");
            return (Criteria) this;
        }

        public Criteria andCostTotalIsNotNull() {
            addCriterion("cost_total is not null");
            return (Criteria) this;
        }

        public Criteria andCostTotalEqualTo(Double value) {
            addCriterion("cost_total =", value, "costTotal");
            return (Criteria) this;
        }

        public Criteria andCostTotalNotEqualTo(Double value) {
            addCriterion("cost_total <>", value, "costTotal");
            return (Criteria) this;
        }

        public Criteria andCostTotalGreaterThan(Double value) {
            addCriterion("cost_total >", value, "costTotal");
            return (Criteria) this;
        }

        public Criteria andCostTotalGreaterThanOrEqualTo(Double value) {
            addCriterion("cost_total >=", value, "costTotal");
            return (Criteria) this;
        }

        public Criteria andCostTotalLessThan(Double value) {
            addCriterion("cost_total <", value, "costTotal");
            return (Criteria) this;
        }

        public Criteria andCostTotalLessThanOrEqualTo(Double value) {
            addCriterion("cost_total <=", value, "costTotal");
            return (Criteria) this;
        }

        public Criteria andCostTotalIn(List<Double> values) {
            addCriterion("cost_total in", values, "costTotal");
            return (Criteria) this;
        }

        public Criteria andCostTotalNotIn(List<Double> values) {
            addCriterion("cost_total not in", values, "costTotal");
            return (Criteria) this;
        }

        public Criteria andCostTotalBetween(Double value1, Double value2) {
            addCriterion("cost_total between", value1, value2, "costTotal");
            return (Criteria) this;
        }

        public Criteria andCostTotalNotBetween(Double value1, Double value2) {
            addCriterion("cost_total not between", value1, value2, "costTotal");
            return (Criteria) this;
        }

        public Criteria andSecurityMoneyIsNull() {
            addCriterion("security_money is null");
            return (Criteria) this;
        }

        public Criteria andSecurityMoneyIsNotNull() {
            addCriterion("security_money is not null");
            return (Criteria) this;
        }

        public Criteria andSecurityMoneyEqualTo(Integer value) {
            addCriterion("security_money =", value, "securityMoney");
            return (Criteria) this;
        }

        public Criteria andSecurityMoneyNotEqualTo(Integer value) {
            addCriterion("security_money <>", value, "securityMoney");
            return (Criteria) this;
        }

        public Criteria andSecurityMoneyGreaterThan(Integer value) {
            addCriterion("security_money >", value, "securityMoney");
            return (Criteria) this;
        }

        public Criteria andSecurityMoneyGreaterThanOrEqualTo(Integer value) {
            addCriterion("security_money >=", value, "securityMoney");
            return (Criteria) this;
        }

        public Criteria andSecurityMoneyLessThan(Integer value) {
            addCriterion("security_money <", value, "securityMoney");
            return (Criteria) this;
        }

        public Criteria andSecurityMoneyLessThanOrEqualTo(Integer value) {
            addCriterion("security_money <=", value, "securityMoney");
            return (Criteria) this;
        }

        public Criteria andSecurityMoneyIn(List<Integer> values) {
            addCriterion("security_money in", values, "securityMoney");
            return (Criteria) this;
        }

        public Criteria andSecurityMoneyNotIn(List<Integer> values) {
            addCriterion("security_money not in", values, "securityMoney");
            return (Criteria) this;
        }

        public Criteria andSecurityMoneyBetween(Integer value1, Integer value2) {
            addCriterion("security_money between", value1, value2, "securityMoney");
            return (Criteria) this;
        }

        public Criteria andSecurityMoneyNotBetween(Integer value1, Integer value2) {
            addCriterion("security_money not between", value1, value2, "securityMoney");
            return (Criteria) this;
        }

        public Criteria andTravelExpenseIsNull() {
            addCriterion("travel_expense is null");
            return (Criteria) this;
        }

        public Criteria andTravelExpenseIsNotNull() {
            addCriterion("travel_expense is not null");
            return (Criteria) this;
        }

        public Criteria andTravelExpenseEqualTo(Integer value) {
            addCriterion("travel_expense =", value, "travelExpense");
            return (Criteria) this;
        }

        public Criteria andTravelExpenseNotEqualTo(Integer value) {
            addCriterion("travel_expense <>", value, "travelExpense");
            return (Criteria) this;
        }

        public Criteria andTravelExpenseGreaterThan(Integer value) {
            addCriterion("travel_expense >", value, "travelExpense");
            return (Criteria) this;
        }

        public Criteria andTravelExpenseGreaterThanOrEqualTo(Integer value) {
            addCriterion("travel_expense >=", value, "travelExpense");
            return (Criteria) this;
        }

        public Criteria andTravelExpenseLessThan(Integer value) {
            addCriterion("travel_expense <", value, "travelExpense");
            return (Criteria) this;
        }

        public Criteria andTravelExpenseLessThanOrEqualTo(Integer value) {
            addCriterion("travel_expense <=", value, "travelExpense");
            return (Criteria) this;
        }

        public Criteria andTravelExpenseIn(List<Integer> values) {
            addCriterion("travel_expense in", values, "travelExpense");
            return (Criteria) this;
        }

        public Criteria andTravelExpenseNotIn(List<Integer> values) {
            addCriterion("travel_expense not in", values, "travelExpense");
            return (Criteria) this;
        }

        public Criteria andTravelExpenseBetween(Integer value1, Integer value2) {
            addCriterion("travel_expense between", value1, value2, "travelExpense");
            return (Criteria) this;
        }

        public Criteria andTravelExpenseNotBetween(Integer value1, Integer value2) {
            addCriterion("travel_expense not between", value1, value2, "travelExpense");
            return (Criteria) this;
        }

        public Criteria andCostFilmIsNull() {
            addCriterion("cost_film is null");
            return (Criteria) this;
        }

        public Criteria andCostFilmIsNotNull() {
            addCriterion("cost_film is not null");
            return (Criteria) this;
        }

        public Criteria andCostFilmEqualTo(Double value) {
            addCriterion("cost_film =", value, "costFilm");
            return (Criteria) this;
        }

        public Criteria andCostFilmNotEqualTo(Double value) {
            addCriterion("cost_film <>", value, "costFilm");
            return (Criteria) this;
        }

        public Criteria andCostFilmGreaterThan(Double value) {
            addCriterion("cost_film >", value, "costFilm");
            return (Criteria) this;
        }

        public Criteria andCostFilmGreaterThanOrEqualTo(Double value) {
            addCriterion("cost_film >=", value, "costFilm");
            return (Criteria) this;
        }

        public Criteria andCostFilmLessThan(Double value) {
            addCriterion("cost_film <", value, "costFilm");
            return (Criteria) this;
        }

        public Criteria andCostFilmLessThanOrEqualTo(Double value) {
            addCriterion("cost_film <=", value, "costFilm");
            return (Criteria) this;
        }

        public Criteria andCostFilmIn(List<Double> values) {
            addCriterion("cost_film in", values, "costFilm");
            return (Criteria) this;
        }

        public Criteria andCostFilmNotIn(List<Double> values) {
            addCriterion("cost_film not in", values, "costFilm");
            return (Criteria) this;
        }

        public Criteria andCostFilmBetween(Double value1, Double value2) {
            addCriterion("cost_film between", value1, value2, "costFilm");
            return (Criteria) this;
        }

        public Criteria andCostFilmNotBetween(Double value1, Double value2) {
            addCriterion("cost_film not between", value1, value2, "costFilm");
            return (Criteria) this;
        }

        public Criteria andCostSecurityIsNull() {
            addCriterion("cost_security is null");
            return (Criteria) this;
        }

        public Criteria andCostSecurityIsNotNull() {
            addCriterion("cost_security is not null");
            return (Criteria) this;
        }

        public Criteria andCostSecurityEqualTo(Double value) {
            addCriterion("cost_security =", value, "costSecurity");
            return (Criteria) this;
        }

        public Criteria andCostSecurityNotEqualTo(Double value) {
            addCriterion("cost_security <>", value, "costSecurity");
            return (Criteria) this;
        }

        public Criteria andCostSecurityGreaterThan(Double value) {
            addCriterion("cost_security >", value, "costSecurity");
            return (Criteria) this;
        }

        public Criteria andCostSecurityGreaterThanOrEqualTo(Double value) {
            addCriterion("cost_security >=", value, "costSecurity");
            return (Criteria) this;
        }

        public Criteria andCostSecurityLessThan(Double value) {
            addCriterion("cost_security <", value, "costSecurity");
            return (Criteria) this;
        }

        public Criteria andCostSecurityLessThanOrEqualTo(Double value) {
            addCriterion("cost_security <=", value, "costSecurity");
            return (Criteria) this;
        }

        public Criteria andCostSecurityIn(List<Double> values) {
            addCriterion("cost_security in", values, "costSecurity");
            return (Criteria) this;
        }

        public Criteria andCostSecurityNotIn(List<Double> values) {
            addCriterion("cost_security not in", values, "costSecurity");
            return (Criteria) this;
        }

        public Criteria andCostSecurityBetween(Double value1, Double value2) {
            addCriterion("cost_security between", value1, value2, "costSecurity");
            return (Criteria) this;
        }

        public Criteria andCostSecurityNotBetween(Double value1, Double value2) {
            addCriterion("cost_security not between", value1, value2, "costSecurity");
            return (Criteria) this;
        }

        public Criteria andCostServiceIsNull() {
            addCriterion("cost_service is null");
            return (Criteria) this;
        }

        public Criteria andCostServiceIsNotNull() {
            addCriterion("cost_service is not null");
            return (Criteria) this;
        }

        public Criteria andCostServiceEqualTo(Double value) {
            addCriterion("cost_service =", value, "costService");
            return (Criteria) this;
        }

        public Criteria andCostServiceNotEqualTo(Double value) {
            addCriterion("cost_service <>", value, "costService");
            return (Criteria) this;
        }

        public Criteria andCostServiceGreaterThan(Double value) {
            addCriterion("cost_service >", value, "costService");
            return (Criteria) this;
        }

        public Criteria andCostServiceGreaterThanOrEqualTo(Double value) {
            addCriterion("cost_service >=", value, "costService");
            return (Criteria) this;
        }

        public Criteria andCostServiceLessThan(Double value) {
            addCriterion("cost_service <", value, "costService");
            return (Criteria) this;
        }

        public Criteria andCostServiceLessThanOrEqualTo(Double value) {
            addCriterion("cost_service <=", value, "costService");
            return (Criteria) this;
        }

        public Criteria andCostServiceIn(List<Double> values) {
            addCriterion("cost_service in", values, "costService");
            return (Criteria) this;
        }

        public Criteria andCostServiceNotIn(List<Double> values) {
            addCriterion("cost_service not in", values, "costService");
            return (Criteria) this;
        }

        public Criteria andCostServiceBetween(Double value1, Double value2) {
            addCriterion("cost_service between", value1, value2, "costService");
            return (Criteria) this;
        }

        public Criteria andCostServiceNotBetween(Double value1, Double value2) {
            addCriterion("cost_service not between", value1, value2, "costService");
            return (Criteria) this;
        }

        public Criteria andPhoneIsNull() {
            addCriterion("phone is null");
            return (Criteria) this;
        }

        public Criteria andPhoneIsNotNull() {
            addCriterion("phone is not null");
            return (Criteria) this;
        }

        public Criteria andPhoneEqualTo(String value) {
            addCriterion("phone =", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneNotEqualTo(String value) {
            addCriterion("phone <>", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneGreaterThan(String value) {
            addCriterion("phone >", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneGreaterThanOrEqualTo(String value) {
            addCriterion("phone >=", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneLessThan(String value) {
            addCriterion("phone <", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneLessThanOrEqualTo(String value) {
            addCriterion("phone <=", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneLike(String value) {
            addCriterion("phone like", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneNotLike(String value) {
            addCriterion("phone not like", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneIn(List<String> values) {
            addCriterion("phone in", values, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneNotIn(List<String> values) {
            addCriterion("phone not in", values, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneBetween(String value1, String value2) {
            addCriterion("phone between", value1, value2, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneNotBetween(String value1, String value2) {
            addCriterion("phone not between", value1, value2, "phone");
            return (Criteria) this;
        }

        public Criteria andStatusIsNull() {
            addCriterion("status is null");
            return (Criteria) this;
        }

        public Criteria andStatusIsNotNull() {
            addCriterion("status is not null");
            return (Criteria) this;
        }

        public Criteria andStatusEqualTo(Integer value) {
            addCriterion("status =", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotEqualTo(Integer value) {
            addCriterion("status <>", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThan(Integer value) {
            addCriterion("status >", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("status >=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThan(Integer value) {
            addCriterion("status <", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThanOrEqualTo(Integer value) {
            addCriterion("status <=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusIn(List<Integer> values) {
            addCriterion("status in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotIn(List<Integer> values) {
            addCriterion("status not in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusBetween(Integer value1, Integer value2) {
            addCriterion("status between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("status not between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andBusinessIsNull() {
            addCriterion("business is null");
            return (Criteria) this;
        }

        public Criteria andBusinessIsNotNull() {
            addCriterion("business is not null");
            return (Criteria) this;
        }

        public Criteria andBusinessEqualTo(String value) {
            addCriterion("business =", value, "business");
            return (Criteria) this;
        }

        public Criteria andBusinessNotEqualTo(String value) {
            addCriterion("business <>", value, "business");
            return (Criteria) this;
        }

        public Criteria andBusinessGreaterThan(String value) {
            addCriterion("business >", value, "business");
            return (Criteria) this;
        }

        public Criteria andBusinessGreaterThanOrEqualTo(String value) {
            addCriterion("business >=", value, "business");
            return (Criteria) this;
        }

        public Criteria andBusinessLessThan(String value) {
            addCriterion("business <", value, "business");
            return (Criteria) this;
        }

        public Criteria andBusinessLessThanOrEqualTo(String value) {
            addCriterion("business <=", value, "business");
            return (Criteria) this;
        }

        public Criteria andBusinessLike(String value) {
            addCriterion("business like", value, "business");
            return (Criteria) this;
        }

        public Criteria andBusinessNotLike(String value) {
            addCriterion("business not like", value, "business");
            return (Criteria) this;
        }

        public Criteria andBusinessIn(List<String> values) {
            addCriterion("business in", values, "business");
            return (Criteria) this;
        }

        public Criteria andBusinessNotIn(List<String> values) {
            addCriterion("business not in", values, "business");
            return (Criteria) this;
        }

        public Criteria andBusinessBetween(String value1, String value2) {
            addCriterion("business between", value1, value2, "business");
            return (Criteria) this;
        }

        public Criteria andBusinessNotBetween(String value1, String value2) {
            addCriterion("business not between", value1, value2, "business");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNull() {
            addCriterion("create_time is null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNotNull() {
            addCriterion("create_time is not null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualTo(Date value) {
            addCriterion("create_time =", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualTo(Date value) {
            addCriterion("create_time <>", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThan(Date value) {
            addCriterion("create_time >", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("create_time >=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThan(Date value) {
            addCriterion("create_time <", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualTo(Date value) {
            addCriterion("create_time <=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIn(List<Date> values) {
            addCriterion("create_time in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotIn(List<Date> values) {
            addCriterion("create_time not in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeBetween(Date value1, Date value2) {
            addCriterion("create_time between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotBetween(Date value1, Date value2) {
            addCriterion("create_time not between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andReceivingTimeIsNull() {
            addCriterion("receiving_time is null");
            return (Criteria) this;
        }

        public Criteria andReceivingTimeIsNotNull() {
            addCriterion("receiving_time is not null");
            return (Criteria) this;
        }

        public Criteria andReceivingTimeEqualTo(Date value) {
            addCriterion("receiving_time =", value, "receivingTime");
            return (Criteria) this;
        }

        public Criteria andReceivingTimeNotEqualTo(Date value) {
            addCriterion("receiving_time <>", value, "receivingTime");
            return (Criteria) this;
        }

        public Criteria andReceivingTimeGreaterThan(Date value) {
            addCriterion("receiving_time >", value, "receivingTime");
            return (Criteria) this;
        }

        public Criteria andReceivingTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("receiving_time >=", value, "receivingTime");
            return (Criteria) this;
        }

        public Criteria andReceivingTimeLessThan(Date value) {
            addCriterion("receiving_time <", value, "receivingTime");
            return (Criteria) this;
        }

        public Criteria andReceivingTimeLessThanOrEqualTo(Date value) {
            addCriterion("receiving_time <=", value, "receivingTime");
            return (Criteria) this;
        }

        public Criteria andReceivingTimeIn(List<Date> values) {
            addCriterion("receiving_time in", values, "receivingTime");
            return (Criteria) this;
        }

        public Criteria andReceivingTimeNotIn(List<Date> values) {
            addCriterion("receiving_time not in", values, "receivingTime");
            return (Criteria) this;
        }

        public Criteria andReceivingTimeBetween(Date value1, Date value2) {
            addCriterion("receiving_time between", value1, value2, "receivingTime");
            return (Criteria) this;
        }

        public Criteria andReceivingTimeNotBetween(Date value1, Date value2) {
            addCriterion("receiving_time not between", value1, value2, "receivingTime");
            return (Criteria) this;
        }

        public Criteria andSuccessTimeIsNull() {
            addCriterion("success_time is null");
            return (Criteria) this;
        }

        public Criteria andSuccessTimeIsNotNull() {
            addCriterion("success_time is not null");
            return (Criteria) this;
        }

        public Criteria andSuccessTimeEqualTo(Date value) {
            addCriterion("success_time =", value, "successTime");
            return (Criteria) this;
        }

        public Criteria andSuccessTimeNotEqualTo(Date value) {
            addCriterion("success_time <>", value, "successTime");
            return (Criteria) this;
        }

        public Criteria andSuccessTimeGreaterThan(Date value) {
            addCriterion("success_time >", value, "successTime");
            return (Criteria) this;
        }

        public Criteria andSuccessTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("success_time >=", value, "successTime");
            return (Criteria) this;
        }

        public Criteria andSuccessTimeLessThan(Date value) {
            addCriterion("success_time <", value, "successTime");
            return (Criteria) this;
        }

        public Criteria andSuccessTimeLessThanOrEqualTo(Date value) {
            addCriterion("success_time <=", value, "successTime");
            return (Criteria) this;
        }

        public Criteria andSuccessTimeIn(List<Date> values) {
            addCriterion("success_time in", values, "successTime");
            return (Criteria) this;
        }

        public Criteria andSuccessTimeNotIn(List<Date> values) {
            addCriterion("success_time not in", values, "successTime");
            return (Criteria) this;
        }

        public Criteria andSuccessTimeBetween(Date value1, Date value2) {
            addCriterion("success_time between", value1, value2, "successTime");
            return (Criteria) this;
        }

        public Criteria andSuccessTimeNotBetween(Date value1, Date value2) {
            addCriterion("success_time not between", value1, value2, "successTime");
            return (Criteria) this;
        }

        public Criteria andStatusAuditIsNull() {
            addCriterion("status_audit is null");
            return (Criteria) this;
        }

        public Criteria andStatusAuditIsNotNull() {
            addCriterion("status_audit is not null");
            return (Criteria) this;
        }

        public Criteria andStatusAuditEqualTo(String value) {
            addCriterion("status_audit =", value, "statusAudit");
            return (Criteria) this;
        }

        public Criteria andStatusAuditNotEqualTo(String value) {
            addCriterion("status_audit <>", value, "statusAudit");
            return (Criteria) this;
        }

        public Criteria andStatusAuditGreaterThan(String value) {
            addCriterion("status_audit >", value, "statusAudit");
            return (Criteria) this;
        }

        public Criteria andStatusAuditGreaterThanOrEqualTo(String value) {
            addCriterion("status_audit >=", value, "statusAudit");
            return (Criteria) this;
        }

        public Criteria andStatusAuditLessThan(String value) {
            addCriterion("status_audit <", value, "statusAudit");
            return (Criteria) this;
        }

        public Criteria andStatusAuditLessThanOrEqualTo(String value) {
            addCriterion("status_audit <=", value, "statusAudit");
            return (Criteria) this;
        }

        public Criteria andStatusAuditLike(String value) {
            addCriterion("status_audit like", value, "statusAudit");
            return (Criteria) this;
        }

        public Criteria andStatusAuditNotLike(String value) {
            addCriterion("status_audit not like", value, "statusAudit");
            return (Criteria) this;
        }

        public Criteria andStatusAuditIn(List<String> values) {
            addCriterion("status_audit in", values, "statusAudit");
            return (Criteria) this;
        }

        public Criteria andStatusAuditNotIn(List<String> values) {
            addCriterion("status_audit not in", values, "statusAudit");
            return (Criteria) this;
        }

        public Criteria andStatusAuditBetween(String value1, String value2) {
            addCriterion("status_audit between", value1, value2, "statusAudit");
            return (Criteria) this;
        }

        public Criteria andStatusAuditNotBetween(String value1, String value2) {
            addCriterion("status_audit not between", value1, value2, "statusAudit");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}